CREATE PROCEDURE [dbo].[ProjectForUser_Get]
	@UserId UNIQUEIDENTIFIER
AS

SELECT 
	p.*
FROM
	tr_Project p
	INNER JOIN tr_ProjectUser pu ON p.ProjectId = pu.ProjectId
WHERE
	pu.UserId = @UserId
 
GO


